select 
Fk.name as parent_foreign_key_name, 
Fk.object_id as parent_object_id,
object_name(Fk.parent_object_id) as fk_table_name, 
schema_name(Fk.schema_id) as fk_table_schema, 
TbR.name as pk_table_name, 
schema_name(TbR.schema_id) pk_table_schema, 
col_name(Fk.parent_object_id, 
fk_Cl.parent_column_id) as fk_col_name, 
col_name(Fk.referenced_object_id, fk_Cl.referenced_column_id) as pk_col_name
from sys.foreign_keys Fk 
left outer join sys.tables TbR on TbR.object_id = Fk.referenced_object_id 
inner join sys.foreign_key_columns fk_Cl on fk_Cl.constraint_object_id = Fk.object_id 
order by Fk.object_id, fk_Cl.constraint_column_id